﻿
CREATE PROCEDURE [dbo].[OPM_ReturnOrderHeader_Update]
(
	@Id  int,
	@WangWangId  nvarchar(50),
	@CustomerName  nvarchar(50),
	@CustomerCellphone  nvarchar(50),
	@CustomerAddress nvarchar(500),
	@UpdatedBy int
)

AS

    UPDATE dbo.[OPM_ReturnOrderHeader]
	SET 
		[WangWangId] = @WangWangId,
		[CustomerAddress] = @CustomerAddress,
		[CustomerName] = @CustomerName,
		[CustomerCellphone] = @CustomerCellphone,
		[UpdatedBy] = @UpdatedBy,
		[UpdatedOn] = getdate()
	WHERE [Id] = @Id